SharedWorkspace![]() ![]() ![]() |
The SharedWorkspaceLink object represents a URL link saved in a shared document workspace. Member of the SharedWorkspaceLinks collection.
Use the SharedWorkspaceLink object to manage links to additional documents and information of interest to the members who are collaborating on the document(s) in the shared workspace.
Use the Item(Index) method of the SharedWorkspaceLinks collection to return a specific SharedWorkspaceLink object.
Use the Description property to set the link description that will appear on the Links tab of the Shared Workspace pane and on the workspace web page. Use the Url property to set the destination address of the link. Use the Notes property to supply additional information about the link.
Use the Save method to upload changes to the server after you modify properties of the SharedWorkspaceLink object.
Use the CreatedBy, CreatedDate, ModifiedBy, and ModifiedDate properties to return information about the history of each link.
The following example modifies the first link in the shared workspace to point to the Microsoft Developer Network home page, then uploads the changes to the server.
Dim swsLink As Office.SharedWorkspaceLink
Set swsLink = ActiveWorkbook.SharedWorkspace.Links(1)
With swsLink
.Description = "MSDN Home Page"
.URL = "http://msdn.microsoft.com/"
.Notes = "My favorite site for developers!"
.Save
End With
Set swsLink = Nothing